﻿/*

******************************************************

CreateDate  *  Author         *  Content

2008-8-15   *  donne.yang     *  The Configuration

******************************************************

NO   *  UpdateDate   *  Author        *  Content

*********************************************************

*/
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.OracleClient;
using System.Collections;
using System.Configuration;

using FoxConn.Lib.Dbo;

namespace ReportLostCard.Source
{
    class OracleUtil
    {
        public OracleUtil()
        { 
        }


        public static DataSet GetDimissionPerson()
        {
            DBOperation dbo = new DBOperation(0);

            //string strSql = "select workno from HRM_EMPLOYEES where status = 2 and workno= 'F3782378'";
            string strSql = "select workno from HRM_EMPLOYEES where status = 2";

            return dbo.GetResult(strSql);
        }

        //public static string GetDimissionPerson()
        //{
        //    string strResult = "";
        //    string strTemp;

        //    DBOperation dbo = new DBOperation(0);

        //    string strSql = "select workno from HRM_EMPLOYEES where status = 2";

        //    DataSet ds = dbo.GetResult(strSql);
        //    if (StaticUtil.IsDsHasData(ds))
        //    {
        //        for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
        //        {
        //            strTemp = "'" + ds.Tables[0].Rows[i][0].ToString() + "'";

        //            if (i == 0)
        //            {
        //                strResult = strTemp;
        //            }
        //            else
        //            {
        //                strResult += "," + strTemp;
        //            }
        //        }
        //    }

        //    return strResult;
        //}
    }
}
